﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using QLTV_Public;
using QLTV_Data;
namespace QLTV_BLL
{
  public  class DocGia_BLL
    {
        DocGia_Data dg = new DocGia_Data();
        public DataTable TaoBang(string sql)
        {
            return dg.TaoBang(sql);
        }
        public DataTable LayDuLieu()
        {
            return dg.LayDuLieu();
        }
        public DataTable Load_DocGia_GiaoVien(string maDocGia, string hoVaTen, Boolean isNgaySinh, DateTime ngaySinh, Boolean isNgayLamThe, DateTime fromNgayLamThe, DateTime toNgayLamThe, Boolean isNgayHetHan, DateTime fromNgayHetHan, DateTime toNgayHetHan)
        {
            return dg.Load_DocGia_GiaoVien(maDocGia, hoVaTen, isNgaySinh, ngaySinh,isNgayLamThe,fromNgayLamThe,toNgayLamThe,isNgayHetHan,fromNgayHetHan,toNgayHetHan);
        }
        public DataTable Load_DocGia_HocVien(string maDocGia, string hoVaTen, Boolean isNgaySinh, DateTime ngaySinh, Boolean isNgayLamThe, DateTime fromNgayLamThe, DateTime toNgayLamThe, Boolean isNgayHetHan, DateTime fromNgayHetHan, DateTime toNgayHetHan)
        {
            return dg.Load_DocGia_HocVien(maDocGia,hoVaTen, isNgaySinh,ngaySinh,isNgayLamThe,fromNgayLamThe, toNgayLamThe,isNgayHetHan,fromNgayHetHan,toNgayHetHan);
        }
        public int Insert(DocGia_Public docGia)
        {
            return dg.Insert(docGia);
        }
        public int Update(DocGia_Public docGia)
        {
            return dg.Update(docGia);
        }
        public int Delete_DocGia_HocVien(string maDocGia)
        {
            return dg.Delete_DocGia_HocVien(maDocGia);
        }
        public int Delete_DocGia_GiaoVien(string maDocGia)
        {
            return dg.Delete_DocGia_GiaoVien(maDocGia);
        }
        public DataTable Load_Muon_SinhVien(PhieuYeuCau_Public obj, string hoTen, DateTime toNgayLapPhieu)
        {
            return dg.Load_Muon_SinhVien(obj,hoTen,toNgayLapPhieu);
        }
        public DataTable Load_GiaoVien(PhieuYeuCau_Public obj, string hoTen, DateTime toNgayLapPhieu)
        {
            return dg.Load_GiaoVien(obj,hoTen,toNgayLapPhieu);
        }
        public int Update_GiaHanThe(DocGia_Public obj)
        {
            return dg.Update_GiaHanThe(obj);
        }
    }
}
